Oracle Notes
Startup
Setting up a new environment for Oracle 8i
Setting up a new environment for Oracle 9i/10g
Installing Oracle 8.1.7
Installing Oracle 9.2.0
Installing Oracle 10.1.0.2
Installing Oracle 10.2.0.1
Installing Oracle 10.2.0.1 companion
Installing Oracle8i Client (only) for Tuxedo
Installing Oracle 10R2 Client
Upgrading to Oracle 8.1.7.2
Relinking Oracle
Create a generic database
Database creation : code respository
Security / Tuning
Installing Oracle monitoring tools (Database Control)
How much Redo-Log does this transaction generate ?
Need to find a count of transactions ?
Discover the passwords for database links
Determine if the Problem is with Net8 or the Network
What is STATSPACK and how does one use it ?
Explain Plan
Default users and passwords created during an Oracle install
Miscellaneous
ORACLE_HOME naming standards
Create a PS database using exp
A potpourri of .sql and .sh scripts
Rollback segments explained
Finding and Fixing out-of-balance indexes
Tracing a user session
Net8 overview
Net8 load balancing of ports
Net8 hodgepodge of notes
Remote Diagnostic Agent
ORACLE10g features
Backup / Recovery
Long Term Retention of Oracle Backups on Legato
Compressing an export on the fly
Quick and dirty cold backup script
Oracle8i LogMiner
Oracle8i Recovery Documentation
Localisms
Xhier
Xhier - xh-imakefile
orabase - a requirement for all databases
Cloning a database with the "refresh" command
Standard crontab entries for oracle and orasysop
Managing the batch queue
UNIXisms
Creation and Distribution of ssh keys
Finding active Oracle databases on a machine
Relationship between init.ora and UNIX kernel parms
UNIX I/O activity, CPU utilization, paging
Converting filesystems to metadevices
Printing on Solaris
Managing tar files
View hardware on a SUN machine
Vendor
Precise
Computer Associates
DBvision
TSreorg
Legato